using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using <Application>.<Business>;

namespace <Application>.<Data>
{
    public class <OwnerU>_<TableU>DataClass
    {

        public static DataTable Select_Records(<DRType> <DRField>)
        {
            using (var context = new <Database>DBContext())
            {
<If Loop>
      <IsFKeyCount>
            var Query = (from _<OwnerU>_<TableU> in context.<OwnerU>_<TableU>
     	<ExitLoop>
</If Loop>
<If Loop>
     <IsFKeyCount>
     <And>
     <IsRelated>
     <And>
     <IsMiscTag>
                        join A<MiscTag>_<ROwner>_<RTable> in context.<ROwner>_<RTable> on _<OwnerU>_<TableU>.<Field> equals A<MiscTag>_<ROwner>_<RTable>.<RField>
     <IsFKeyCount>
     <And>
     <IsRelated>
     <And>
     <IsNotMiscTag>
                        join _<ROwner>_<RTable> in context.<ROwner>_<RTable> on _<OwnerU>_<TableU>.<Field> equals _<ROwner>_<RTable>.<RField>
</If Loop>
                        where _<DOwner>_<DTable>.<DRField> == <DRField>                        
<If Loop>
      <IsFKeyCount>
                        select new <OwnerU>_<TableU>Joined() {
     	<ExitLoop>
</If Loop>
<If Loop>
     <IsFKeyCount>
     <And>
     <IsComboBox (Db)>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                            <Field> = A<MiscTag>_<ROwner>_<RTable>.<RDisplayFieldU>
     <IsFKeyCount>
     <And>
     <IsComboBox (Db)>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                           ,<Field> = A<MiscTag>_<ROwner>_<RTable>.<RDisplayFieldU>
     <IsFKeyCount>
     <And>
     <IsComboBox (Db)>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                            <Field> = _<ROwner>_<RTable>.<RDisplayFieldU>
     <IsFKeyCount>
     <And>
     <IsComboBox (Db)>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                           ,<Field> = _<ROwner>_<RTable>.<RDisplayFieldU>
     <IsFKeyCount>
     <And>
     <IsNotComboBox (Db)>
     <And>
     <IsCurRow=[0]>
                            <Field> = _<OwnerU>_<TableU>.<Field>
     <IsFKeyCount>
     <And>
     <IsNotComboBox (Db)>
     <And>
     <IsCurRow<>[0]>
                           ,<Field> = _<OwnerU>_<TableU>.<Field>
</If Loop>
<If Loop>
      <IsFKeyCount>
                        }).AsQueryable();

                return Query.ToList().ToDataTable<<OwnerU>_<TableU>Joined>();
     	<ExitLoop>
</If Loop>
<If Loop>
      <IsNotFKeyCount>
                return context.<OwnerU>_<TableU>.ToList().ToDataTable<<OwnerU>_<TableU>>();
     	<ExitLoop>
</If Loop>
            }
        }

        public static DataTable Search(<DRType> <DRField>, string sField, string sCondition, string sValue)
        { 
            using (var context = new <Database>DBContext())
            {
<If Loop>
      <IsNotFKeyCount>
                var Query = context.<OwnerU>_<TableU>.AsQueryable<<OwnerU>_<TableU>>();
     	<ExitLoop>
</If Loop>
<If Loop>
      <IsFKeyCount>
                var Query = (from _<OwnerU>_<TableU> in context.<OwnerU>_<TableU>
     	<ExitLoop>
</If Loop>
<If Loop>
     <IsFKeyCount>
     <And>
     <IsRelated>
     <And>
     <IsMiscTag>
                        join A<MiscTag>_<ROwner>_<RTable> in context.<ROwner>_<RTable> on _<OwnerU>_<TableU>.<Field> equals A<MiscTag>_<ROwner>_<RTable>.<RField>
     <IsFKeyCount>
     <And>
     <IsRelated>
     <And>
     <IsNotMiscTag>
                        join _<ROwner>_<RTable> in context.<ROwner>_<RTable> on _<OwnerU>_<TableU>.<Field> equals _<ROwner>_<RTable>.<RField>
</If Loop>
                        where _<DOwner>_<DTable>.<DRField> == <DRField>  
<If Loop>
      <IsFKeyCount>
                        select new <OwnerU>_<TableU>Joined() {
     	<ExitLoop>
</If Loop>
<If Loop>
     <IsFKeyCount>
     <And>
     <IsComboBox (Db)>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                            <Field> = A<MiscTag>_<ROwner>_<RTable>.<RDisplayFieldU>
     <IsFKeyCount>
     <And>
     <IsComboBox (Db)>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                           ,<Field> = A<MiscTag>_<ROwner>_<RTable>.<RDisplayFieldU>
     <IsFKeyCount>
     <And>
     <IsComboBox (Db)>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                            <Field> = _<ROwner>_<RTable>.<RDisplayFieldU>
     <IsFKeyCount>
     <And>
     <IsComboBox (Db)>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                           ,<Field> = _<ROwner>_<RTable>.<RDisplayFieldU>
     <IsFKeyCount>
     <And>
     <IsNotComboBox (Db)>
     <And>
     <IsCurRow=[0]>
                            <Field> = _<OwnerU>_<TableU>.<Field>
     <IsFKeyCount>
     <And>
     <IsNotComboBox (Db)>
     <And>
     <IsCurRow<>[0]>
                           ,<Field> = _<OwnerU>_<TableU>.<Field>
</If Loop>
<If Loop>
      <IsFKeyCount>
                        }).AsQueryable();
     	<ExitLoop>
</If Loop>
            try {
                if (sValue != null)
                {
                    if (sCondition == "Contains") {
                        Query = Query.Where(p => 
    <If Loop>
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotNull>
   	<And>
   	<IsCurRow=[0]>
                                                 ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().Contains(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNotNullable>
   	<And>
   	<IsCurRow=[0]>
                                                 ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().Contains(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsRDisplayField>
        <And>
   	<IsCurRow=[0]>
                                                 ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().Contains(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsNotRDisplayField>
        <And>
   	<IsCurRow=[0]>
                                                 ("<FieldC>".ToString().Equals(sField) && p.<Field>.Value.ToString().Contains(sValue)) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotNull>
   	<And>
   	<IsCurRow<>[0]>
                                                 || ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().Contains(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNotNullable>
   	<And>
   	<IsCurRow<>[0]>
                                                 || ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().Contains(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsRDisplayField>
        <And>
   	<IsCurRow<>[0]>
                                                 || ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().Contains(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsNotRDisplayField>
        <And>
   	<IsCurRow<>[0]>
                                                 || ("<FieldC>".ToString().Equals(sField) && p.<Field>.Value.ToString().Contains(sValue)) 
    </If Loop>
                                         );
                    } else if (sCondition == "Starts with...") {
                        Query = Query.Where(p => 
    <If Loop>
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotNull>
   	<And>
   	<IsCurRow=[0]>
                                                 ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().StartsWith(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNotNullable>
   	<And>
   	<IsCurRow=[0]>
                                                 ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().StartsWith(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsRDisplayField>
        <And>
   	<IsCurRow=[0]>
                                                 ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().StartsWith(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsNotRDisplayField>
        <And>
   	<IsCurRow=[0]>
                                                 ("<FieldC>".ToString().Equals(sField) && p.<Field>.Value.ToString().StartsWith(sValue)) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotNull>
   	<And>
   	<IsCurRow<>[0]>
                                                 || ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().StartsWith(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNotNullable>
   	<And>
   	<IsCurRow<>[0]>
                                                 || ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().StartsWith(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsRDisplayField>
        <And>
   	<IsCurRow<>[0]>
                                                 || ("<FieldC>".ToString().Equals(sField) && p.<Field>.ToString().Trim().ToLower().StartsWith(sValue.Trim().ToLower())) 
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsNotRDisplayField>
        <And>
   	<IsCurRow<>[0]>
                                                 || ("<FieldC>".ToString().Equals(sField) && p.<Field>.Value.ToString().StartsWith(sValue)) 
    </If Loop>
                                         );
                    } else if (sCondition == "Equals") {
    <If Loop>
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotNull>
   	<And>
   	<IsCurRow=[0]>
                        if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> == m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNotNullable>
   	<And>
   	<IsCurRow=[0]>
                        if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> == m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsRDisplayField>
        <And>
   	<IsCurRow=[0]>
                        if ("<FieldC>".Equals(sField)) { var m<Field> = sValue; Query = Query.Where(p => p.<Field> == m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsNotRDisplayField>
        <And>
   	<IsCurRow=[0]>
                        if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> == m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotNull>
   	<And>
   	<IsCurRow<>[0]>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> == m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNotNullable>
   	<And>
   	<IsCurRow<>[0]>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> == m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsRDisplayField>
        <And>
        <IsNotComboBox (Db)>
        <And>
   	<IsCurRow<>[0]>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> == m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsRDisplayField>
        <And>
        <IsComboBox (Db)>
        <And>
   	<IsCurRow<>[0]>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = sValue; Query = Query.Where(p => p.<Field> == m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
   	<IsNull>
   	<And>
   	<IsNullable>
   	<And>
        <IsNotRDisplayField>
        <And>
   	<IsCurRow<>[0]>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> == m<Field>); }
    </If Loop>
                    } else if (sCondition == "More than...") { 
                        if (sField.Equals(sCondition)) { }
<If Loop>
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotRelated>
   	<And>
        <IsNumber>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> > m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsRelated>
   	<And>
        <IsNotRDisplayField>
   	<And>
        <IsNumber>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> > m<Field>); }
        <IsDateTimePicker>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> > m<Field>); }
</If Loop>
                    } else if (sCondition == "Less than...") { 
                        if (sField.Equals(sCondition)) { }
<If Loop>
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotRelated>
   	<And>
        <IsNumber>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> < m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsRelated>
   	<And>
        <IsNotRDisplayField>
   	<And>
        <IsNumber>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> < m<Field>); }
        <IsDateTimePicker>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> < m<Field>); }
</If Loop>
                    } else if (sCondition == "Equal or more than...") { 
                        if (sField.Equals(sCondition)) { }
<If Loop>
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotRelated>
   	<And>
        <IsNumber>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> >= m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsRelated>
   	<And>
        <IsNotRDisplayField>
   	<And>
        <IsNumber>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> >= m<Field>); }
        <IsDateTimePicker>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> >= m<Field>); }
</If Loop>
                    } else if (sCondition == "Equal or less than...") { 
                        if (sField.Equals(sCondition)) { }
<If Loop>
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsNotRelated>
   	<And>
        <IsNumber>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> <= m<Field>); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
   	<And>
        <IsRelated>
   	<And>
        <IsNotRDisplayField>
   	<And>
        <IsNumber>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> <= m<Field>); }
        <IsDateTimePicker>
                        else if ("<FieldC>".Equals(sField)) { var m<Field> = <Convert>(sValue); Query = Query.Where(p => p.<Field> <= m<Field>); }
</If Loop>
                    }
                }
            } catch (Exception) { }
<If Loop>
      <IsFKeyCount>
            return Query.ToList().ToDataTable<<OwnerU>_<TableU>Joined>();
     	<ExitLoop>
</If Loop>
<If Loop>
      <IsNotFKeyCount>
            return Query.ToList().ToDataTable<<OwnerU>_<TableU>>();
     	<ExitLoop>
</If Loop>
            }
        }

        public static <OwnerU>_<TableU> Select_Record(<OwnerU>_<TableU> _<OwnerU>_<TableU>)
        {
            using (var context = new <Database>DBContext())
            {
                return context.<OwnerU>_<TableU>.Find(
    <If Loop>
      <IsPKey>
      <And>
      <IsCurRow=[0]>
                                                 _<OwnerU>_<TableU>.<FieldU>
      <IsPKey>
      <And>
      <IsCurRow<>[0]>
                                                , _<OwnerU>_<TableU>.<FieldU>
    </If Loop>
                                            );
            }
        }

        public static bool Add(<OwnerU>_<TableU> _<OwnerU>_<TableU>)
        {
            using (var context = new <Database>DBContext())
            {
                context.<OwnerU>_<TableU>.Add(_<OwnerU>_<TableU>);
                return context.SaveChanges() > 0;
            }
        }

        public static bool Update(<OwnerU>_<TableU> _<OwnerU>_<TableU>)
        {
            using (var context = new <Database>DBContext())
            {    
                context.<OwnerU>_<TableU>.Attach(_<OwnerU>_<TableU>);
                context.Entry(_<OwnerU>_<TableU>).State = System.Data.Entity.EntityState.Modified;
                return context.SaveChanges() > 0;
            }
        }

        public static bool Delete(<OwnerU>_<TableU> _<OwnerU>_<TableU>)
        {
            try
            {
                using (var context = new <Database>DBContext())
                {
                    context.<OwnerU>_<TableU>.Remove(context.<OwnerU>_<TableU>.Find(
    <If Loop>
      <IsPKey>
      <And>
      <IsCurRow=[0]>
                                                 _<OwnerU>_<TableU>.<FieldU>
      <IsPKey>
      <And>
      <IsCurRow<>[0]>
                                                , _<OwnerU>_<TableU>.<FieldU>
    </If Loop>
                                            ));
                    return context.SaveChanges() > 0;
                }       
            }
            catch (Exception) { }
            return true;
        }

        public static bool Delete(<DRType> <DRField>)
        {
            try
            {
                using (var context = new <Database>DBContext())
                {
                    var Query = (from _<OwnerU>_<TableU> in context.<OwnerU>_<TableU>
                                 where _<OwnerU>_<TableU>.<DRField> == <DRField>
                                 select _<OwnerU>_<TableU>).AsQueryable();
                    <OwnerU>_<TableU> _<OwnerU>_<TableU>_ = Query.First();
                    context.<OwnerU>_<TableU>.Remove(_<OwnerU>_<TableU>_);
                    return context.SaveChanges() > 0;
                }       
            }
            catch (Exception) { }
            return true;
        }
   
    }
}
